CREATE VIEW [dbo].[V_Update_Delete_Factors]
As
SELECT        dbo.headH.Id_Havaleh, dbo.headH.User_id, dbo.Havaleh.Reciver, dbo.headH.Note, dbo.headH.Tarikh_faktor, dbo.headH.Recive_Name, dbo.headH.Trans_Name, dbo.headH.Number_bar, dbo.headH.Nu_Bargasht_kharid, 
                         dbo.headH.Nu_Bargasht_Forosh, dbo.headH.Nu_Kharid, dbo.headH.Nu_Forosh, dbo.headH.Kind_Flag, dbo.Havaleh.Sender, dbo.Havaleh.K_Qty1, dbo.KalaId.K_Code, dbo.Havaleh.Radif, dbo.Havaleh.Price_KHarid, 
                         dbo.Havaleh.Price_Omdeh, dbo.Havaleh.Price_Forosh, dbo.Unit1.Name, dbo.KalaId.Name1, dbo.Havaleh.AutoId, dbo.Havaleh.Price_KHarid * dbo.Havaleh.K_Qty1 AS TotKharid, 
                         dbo.Havaleh.Price_Forosh * dbo.Havaleh.K_Qty1 AS ToForosh, dbo.Havaleh.Price_Omdeh * dbo.Havaleh.K_Qty1 AS TotOmdeh, dbo.headH.Nu_Resid, dbo.Havaleh.K_Qty2, dbo.Havaleh.R_Unit1_2, dbo.headH.Nu_Havaleh, 
                         dbo.Havaleh.Note AS Expr1, dbo.Havaleh.Avg_Price, CONVERT(varchar(5), dbo.headH.Tarikh, 108) AS Invoicetime
FROM            dbo.Unit1 INNER JOIN
                         dbo.KalaId ON dbo.Unit1.U_Code1 = dbo.KalaId.U_Code1 INNER JOIN
                         dbo.headH INNER JOIN
                         dbo.Havaleh ON dbo.headH.Id_Havaleh = dbo.Havaleh.Id_Havaleh ON dbo.KalaId.K_Code = dbo.Havaleh.K_Code